Restoring Backup File to our Database. 5
Step 1. Click on to download Recsta source script
Download and Extract the Data File.
Step 2. Assuming you have done Step 1 Successfully. Open SSMS/Right click on Database inside your Object Explorer/on the properties pane, click on Restore Database..
Step 3. Select Device: as your source/ Click on the three dots on the right side/ On the Select Backup Devices pane, click on Add/ On the Locate Backup File Select the BAK file and hit OK
Step 4. In the next small window that will open, click on ‘Add’ to go to the local Backup file folder where you initially saved the source document (Step 1).
Step 5. In the ‘Local Backup File’ folder, click on the source file to restore and then click on ‘Ok’
Step 6. Now, you are back on to the small screen where you clicked on ‘Add’, here just highlight the file you just added by clicking on it and click on ‘Ok’.
Step 7. Make sure the progress shows a green circle spinning and then shows ‘Done’ as in Step 8.
Step 8. From the Destination Database Dropdowns Select ‘RecSta’ and then you will see an item stated in the restore plan
Step 9. Then click ‘Ok’. This will restore the source database. Please refer to the below motion screen for detail
[Figure ]
Backup and Restore a SQL Server:
Restoring Backup File to our Database. 5Step 1. Click on to download Recsta source script
Download and Extract the Data File.
Step 2. Assuming you have done Step 1 Successfully. Open SSMS/Right click on Database inside your Object Explorer/on the properties pane, click on Restore Database..
Step 3. Select Device: as your source/ Click on the three dots on the right side/ On the Select Backup Devices pane, click on Add/ On the Locate Backup File Select the BAK file and hit OK
Step 4. In the next small window that will open, click on ‘Add’ to go to the local Backup file folder where you initially saved the source document (Step 1).
Step 5. In the ‘Local Backup File’ folder, click on the source file to restore and then click on ‘Ok’
Step 6. Now, you are back on to the small screen where you clicked on ‘Add’, here just highlight the file you just added by clicking on it and click on ‘Ok’.
Step 7. Make sure the progress shows a green circle spinning and then shows ‘Done’ as in Step 8.
Step 8. From the Destination Database Dropdowns Select ‘RecSta’ and then you will see an item stated in the restore plan
Step 9. Then click ‘Ok’. This will restore the source database. Please refer to the below motion screen for detail
[Figure ]
Backup and Restore a SQL Server: